GetColumnSize

Definition:

GetColumnSize(datasource, field, currentrecord)

Description:

Obtain the size of the data (in bytes) within a Data Source column – either for a single record or the sum of all records.

Platforms:

All

Parameters:

datasource - required

Specifies the Data Source containing the relevant column – click here for the format of this parameter.

The Data Source can be a Custom View.

field - required

Name of the column within the Data Source whose size you want to know.

currentrecord - required

Determines whether the Method should return the column size for the current record only or the sum of the column sizes in all records. It can take one of the following values:

True, "True", 1 or "1" - Obtain the size of the column in the current record of the specified Data Source.

False, "False", 0 or "0" - Obtain the sum of the data in the specified column for all records in the specified Data Source.

Returns:

The size of the data in bytes.

Notes:

This Method can be used with binary data type columns, e.g. binary, varbinary and image data types, and character string column data types, e.g. nvarchar.